/*
 Navicat Premium Data Transfer

 Source Server         : SMSDB
 Source Server Type    : SQLite
 Source Server Version : 3007003
 Source Database       : main

 Target Server Type    : SQLite
 Target Server Version : 3007003
 File Encoding         : utf-8

 Date: 08/13/2012 15:06:47 PM
*/

PRAGMA foreign_keys = false;

-- ----------------------------
--  Table structure for "smsserver_in"
-- ----------------------------
DROP TABLE IF EXISTS "smsserver_in";
CREATE TABLE `smsserver_in` (
  `id` INTEGER PRIMARY KEY AUTOINCREMENT, 
  `process` int(11) NOT NULL,
  `originator` varchar(16) NOT NULL,
  `type` varchar(1) NOT NULL,
  `encoding` char(1) NOT NULL,
  `message_date` datetime NOT NULL,
  `receive_date` datetime NOT NULL,
  `text` varchar(1000) NOT NULL,
  `original_ref_no` varchar(64) DEFAULT NULL,
  `original_receive_date` datetime DEFAULT NULL,
  `gateway_id` varchar(64) DEFAULT NULL
);

-- ----------------------------
--  Records of "smsserver_in"
-- ----------------------------
BEGIN;
INSERT INTO "smsserver_in" VALUES ('1', '0', '628563004073', 'I', '7', X'31333434383335303437363632', X'31333434383335303531373034', 'A d m t j g p t w m j a d j', null, null, 'modem.com1');
INSERT INTO "smsserver_in" VALUES ('2', '0', '08563004073', 'S', '7', X'31333434383335323935333635', X'31333434383335333034343037', '00 - Succesful Delivery.', '177', X'31333434383335333030333635', 'modem.com1');
INSERT INTO "smsserver_in" VALUES ('3', '0', '628563004073', 'I', '7', X'31333434383339323033363734', X'31333434383430323935373139', 'A t j g m p w t d g w t p j m', null, null, 'modem.com1');
INSERT INTO "smsserver_in" VALUES ('4', '0', '08563004073', 'S', '7', X'31333434383430323938363335', X'31333434383430333039363736', '00 - Succesful Delivery.', '178', X'31333434383430333033363335', 'modem.com1');
INSERT INTO "smsserver_in" VALUES ('5', '0', '628815015640', 'I', '7', X'31333434383432333037353639', X'31333434383432333131363538', 'Ghvgt hgv  v vb ', null, null, 'modem.com1');
INSERT INTO "smsserver_in" VALUES ('6', '0', '628563004073', 'I', '7', X'31333434383434373531303232', X'31333434383434373536303935', 'Ad tj mj pg ja tjm wjga damjwt', null, null, 'modem.com1');
COMMIT;

PRAGMA foreign_keys = true;
